Hi All,

I am trying to create a collection based on the disk space less than 5% and send them custom script messages using advertisement.

I have created the collection based on the query free space less than 1GB but not successful in terms percentage free space.

Please advice.

QUERY: 

select
SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId where SMS_G_System_LOGICAL_DISK.FreeSpace <= 1000

Regards,

Fred

I'm not near my CM07 console but this should work... Watch out for typo as I wrote this free hand.

select
 	SMS_R_SYSTEM.ResourceID,
	SMS_R_SYSTEM.ResourceType,
	SMS_R_SYSTEM.Name,
	SMS_R_SYSTEM.SMSUniqueIdentifier,
	SMS_R_SYSTEM.ResourceDomainORWorkgroup,
	SMS_R_SYSTEM.Client 
from 
	SMS_R_System 
	inner join SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId 
where 
	(SMS_G_System_LOGICAL_DISK.FreeSpace / SMS_G_System_LOGICAL_DISK.Size) < 0.05

Hi,

Thanks for the reply, however "((SMS_G_System_LOGICAL_DISK.FreeSpace / SMS_G_System_LOGICAL_DISK.Size) < 0.05)" returns error. 

I could have sworn that you could do basic math in WQL but after looking up WQL stuff, it looks like you can't. so... you are out of luck..

You may refer to the query in the following article to see if it helps:

http://blogs.technet.com/b/manageabilityguys/archive/2010/03/10/being-proactive-with-configmgr-users-with-low-disk-space.aspx